count_scenery_info = "SELECT COUNT(*) count FROM TRAVEL_SCENERY_INFO1 WHERE NAME=%(name)s AND DISTRICT=%(district)s"
def count_scenery_info_param(name, district):
    return ({"name":name,"district":district})

insert_scenery_info = "INSERT INTO TRAVEL_SCENERY_INFO1 (name, scenery_type, district, address, longitude, latitude, star, status, flag, create_no, create_time)" \
                      "VALUES (%(name)s, '026', %(district)s, %(address)s, %(longitude)s, %(latitude)s, 5, '00', '00', 'python', NOW())"
def insert_scenery_info_param(name, district, address, longitude, latitude):
    return ({"name":name,"district":district,"address":address,"longitude":longitude,"latitude":latitude})